UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fmTULKH9zHzYKRD0lQO+YWFUZ+klGrBBuEiLAI5+hc='
WHERE
key_id = 'cf533057f06e38c180fb09721cf5f704ad239ffa7a9789c8cc58ee997ae28974'
AND (
token = '8fmTULKH9zHzYKRD0lQO+YWFUZ+klGrBBuEiLAI5+hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)