UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3PL43oPkL5kLF46xfvBtoRJkKSa6MzUtbCF1dFC0Xkw='
WHERE
key_id = '9fbe01754d10e2612f0ce9b5901427661fc26972a38f0285db0e0f41acc0cd4e'
AND (
token = '3PL43oPkL5kLF46xfvBtoRJkKSa6MzUtbCF1dFC0Xkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)