UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8sPvTxH4fwUVA4cXV9kbqlXGJeG+q0TS/NMnFcg4Vi4='
WHERE
key_id = '90c3cab1a61cde470b10b95a5f7b8fd190c4383c194409c0e66ff22179e4468a'
AND (
token = '8sPvTxH4fwUVA4cXV9kbqlXGJeG+q0TS/NMnFcg4Vi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)