UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NXEr07gmb0DYufEVGHAY1tXFvQfPVzYUwk6Xuw2nFQ='
WHERE
key_id = '67969a29d056e25ddd294dc8fced4ac644d938ee2c1b4fa9082b70905742ccf5'
AND (
token = '7NXEr07gmb0DYufEVGHAY1tXFvQfPVzYUwk6Xuw2nFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)