UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iFxwgXDelqPrVTd5KvN0ESfALNcLWs7zRoPd6+1wsBg='
WHERE
key_id = '10b4c5c44206d446cd6648870faec18222f3d73edb2f660e9c768508a77d2721'
AND (
token = 'iFxwgXDelqPrVTd5KvN0ESfALNcLWs7zRoPd6+1wsBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)