UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w0c0OZgXcKPjeXkiuLf+0Dem1As/MPsUwBNj2bklOj8='
WHERE
key_id = 'd107bbe772b46893c8264ad7d54dedd11aeb3913647d229d5ba5859bdab454df'
AND (
token = 'w0c0OZgXcKPjeXkiuLf+0Dem1As/MPsUwBNj2bklOj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)