UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2XJgRvcQkDeayZ7B+f4ammAM4nmzxd5RlLAp+X0U6CA='
WHERE
key_id = 'a258eb5f06a9c586cd610abc5dd9415a37ee8492f489014b71f600de47a8b4cd'
AND (
token = '2XJgRvcQkDeayZ7B+f4ammAM4nmzxd5RlLAp+X0U6CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)