UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgFG7zpkOR7CKrpffCyzrnPDSebQZRF0sT698Es/7wA='
WHERE
key_id = '31b8990f2f2b2c062e2a3ceb52f7f3f298f555dd92437e6e569276799dbdea2b'
AND (
token = 'XgFG7zpkOR7CKrpffCyzrnPDSebQZRF0sT698Es/7wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)