UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '127AgPxUtl7u1VHLX5HI20g+uybG+Fanqpi62ho2Hlk='
WHERE
key_id = '05ead87330c951807ff519e606e7967d98b4c5a54f5d5c41662c7d597bbba9c3'
AND (
token = '127AgPxUtl7u1VHLX5HI20g+uybG+Fanqpi62ho2Hlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)