UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YWQbP9VKMcJB031X8/p0VYMi/n6pJj2/h/rX2lT4Y2E='
WHERE
key_id = '304e9f1ec735c341e037ac08df726759856a7732b272c8455aae82a05e994f2d'
AND (
token = 'YWQbP9VKMcJB031X8/p0VYMi/n6pJj2/h/rX2lT4Y2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)