UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CrXV0TEtHB1TRErJRMJcXSz6D03lTdbaL1Y2iqv7A8='
WHERE
key_id = 'ca56bb5eb637b26560023868d7cc3d13d0fe85edc0f85f737fa166196959e741'
AND (
token = '8CrXV0TEtHB1TRErJRMJcXSz6D03lTdbaL1Y2iqv7A8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)