UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qyUz5X6VXaTlo4tpJzOrO1BzW8N8G/CRLF7eT2wS2pA='
WHERE
key_id = 'ca74e864542f8785fc2968e0c017d003ae4b09257fb220151d37237b3d3ff73e'
AND (
token = 'qyUz5X6VXaTlo4tpJzOrO1BzW8N8G/CRLF7eT2wS2pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)