UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aL0Rme0XsPBT6UPThTX7FhJB+WUb1s7qi2+Ui39ydAE='
WHERE
key_id = 'c8b3e8a21cab29af76a2e9ae2e93e5d077663a0034d942f2466477eef190ee3e'
AND (
token = 'aL0Rme0XsPBT6UPThTX7FhJB+WUb1s7qi2+Ui39ydAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)