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