UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yWcp+Fu8BCXc/jqi8ItetqpPpdgruCyd6b5pWerJok='
WHERE
key_id = '9a4bf13f9751d17987d6c9656d8b9d690195c6987310789d1f8187cbfd8d069a'
AND (
token = '8yWcp+Fu8BCXc/jqi8ItetqpPpdgruCyd6b5pWerJok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)