UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bN3H7zjpiZkj+ym6tK9sM15jQK155IFpEC3/6ZUl+o='
WHERE
key_id = 'b5031beceeefca3325cf02a0f0739f674eb7786f67030aa72d577d5f0027014c'
AND (
token = '8bN3H7zjpiZkj+ym6tK9sM15jQK155IFpEC3/6ZUl+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)