UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jC1DsBpSrbxQtgFzm0u4gKD8ZDZeCzq0gF4WoDVAwRI='
WHERE
key_id = '77ce7747e0ff2882fa6771fdae20f5befa791d97fbd708478833c57a67da9424'
AND (
token = 'jC1DsBpSrbxQtgFzm0u4gKD8ZDZeCzq0gF4WoDVAwRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)