UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1VR8dGkHBBIczBcRxVkooqcZ4okfxP9I8phuVLN17X8='
WHERE
key_id = 'e9e4b19bee4298ce9a882355524316635b703a53d621be4f65f4f56c5907ac0c'
AND (
token = '1VR8dGkHBBIczBcRxVkooqcZ4okfxP9I8phuVLN17X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)