UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Tm2xouPZxER0gMeQmDXr8dhTDuchvjD5o/qhQT93LE='
WHERE
key_id = 'bf4931509f847aced860639fac8f5b8e4aa27a7ec8dd493abb57b06521753c25'
AND (
token = '3Tm2xouPZxER0gMeQmDXr8dhTDuchvjD5o/qhQT93LE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)