UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gAZwe9t1aJxkGMgXf9b+XmT9yJzTa9sIn6NGpg6baOw='
WHERE
key_id = 'bd2e18e2247afc83d361b5cb55900b25256528a5d02ebb8aaa11143992f4de57'
AND (
token = 'gAZwe9t1aJxkGMgXf9b+XmT9yJzTa9sIn6NGpg6baOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)