UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcCWmKakw2Iqq7LkPmd3/bsBPd7xpqALO/jUywcBhws='
WHERE
key_id = '58e29c7c31002cd10ca05b4e5310831785256a41d24e04ba583b3c4d33209fd5'
AND (
token = 'NcCWmKakw2Iqq7LkPmd3/bsBPd7xpqALO/jUywcBhws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)