UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vL8AEXOULWaKkXk63MM4QjEP42y9Jeutr1rZgzOb8X4='
WHERE
key_id = 'f29ad53b264d42c207c300cff5f0df38a2ed2ec176875f2ce4ec3f6de75a3c0c'
AND (
token = 'vL8AEXOULWaKkXk63MM4QjEP42y9Jeutr1rZgzOb8X4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)