UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ItW6rPPS/kq17nQhCPqUe5W0I5HUnbF0DiL7JukNMQo='
WHERE
key_id = '0d9948b2ff4de57da91ffb8c6786abb18bbbd2444a6991b66bef5e03719fc59a'
AND (
token = 'ItW6rPPS/kq17nQhCPqUe5W0I5HUnbF0DiL7JukNMQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)