UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vM7g5gX/iLN1Yq1j/cpAmsA2ufb1BCtUZ+3H0tMrpbo='
WHERE
key_id = 'e87b4d933b8b466ef9755b66e65179fc967f12c5c90b07e6c3261ee916468b38'
AND (
token = 'vM7g5gX/iLN1Yq1j/cpAmsA2ufb1BCtUZ+3H0tMrpbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)