UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aiFdpqzV6HbcBzdmr7bdFqcADxDUV37S5bTZtXdSflk='
WHERE
key_id = 'de6895e7c4426af4d72700d75f334ec2c3d23b01bc5da4014c4d51a59d69cbc5'
AND (
token = 'aiFdpqzV6HbcBzdmr7bdFqcADxDUV37S5bTZtXdSflk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)