UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGJvK2/hBtdxbTriNEHU5itjBxD205CTn3CwAA8kTFQ='
WHERE
key_id = 'd47d03fbc826026feae56e1ac094151e2d987ea2e4c8f458d1732b29db0d043a'
AND (
token = 'CGJvK2/hBtdxbTriNEHU5itjBxD205CTn3CwAA8kTFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)