UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WbIm4YjfEM66H0jNMsiZLihFlIZdCaiaGR28Gvqlvc4='
WHERE
key_id = '6737b4a42079f7145746c139ba9f7f6c9d519e8abac6c52a3d5a33af0d298457'
AND (
token = 'WbIm4YjfEM66H0jNMsiZLihFlIZdCaiaGR28Gvqlvc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)