UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SvGA00eYkxEYyBA0gox4SF5q7RiV3t8UIWw6AYNSJg='
WHERE
key_id = '3a49c2a6f1625f7fcf96a89621e32829fed763393b71e62905b1ed5befd30274'
AND (
token = '3SvGA00eYkxEYyBA0gox4SF5q7RiV3t8UIWw6AYNSJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)