UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nL9sSeZuGcW6igKOY1rrLG014pXQzCqF/EWBu2VD8p0='
WHERE
key_id = 'e6fc747bcd594213fbdaa4fae81a8182bfba6f05177191c18babbfd5650ceece'
AND (
token = 'nL9sSeZuGcW6igKOY1rrLG014pXQzCqF/EWBu2VD8p0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)