UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SaNbn3vZ+nC8eDiZbCCtdaFBETK3k2ePo7ypLDP40hg='
WHERE
key_id = '563d870c58418722de07e40cd9b37b9a59d06b5ece44d3adf372b05df9dec746'
AND (
token = 'SaNbn3vZ+nC8eDiZbCCtdaFBETK3k2ePo7ypLDP40hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)