UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LCnNhkh2oAYi36TiTsocAUK45BR9H8sEqYm7RW1YxqM='
WHERE
key_id = '4f1ff71d1186939f42ee1ff090c8b3d16266191f2fde392676883f958b016452'
AND (
token = 'LCnNhkh2oAYi36TiTsocAUK45BR9H8sEqYm7RW1YxqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)