UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piWchlU0tmynWk7zj9Zq9zyEv59kHOgAphbAB4KvNJI='
WHERE
key_id = '1dff957231871b780273065fc28c0b46ceef3e49a5cadcc156493964142c52ed'
AND (
token = 'piWchlU0tmynWk7zj9Zq9zyEv59kHOgAphbAB4KvNJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)