UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7QEr+j87KRuR9i0Ej9Fn6SHI6D889DaB8tzSrPD9Gw='
WHERE
key_id = '2dd8045306ba930a7f11150a5fee27cf73e44640e7b2d49d43ab5c18bf6f2be9'
AND (
token = 'S7QEr+j87KRuR9i0Ej9Fn6SHI6D889DaB8tzSrPD9Gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)