UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNEjxAR8hirv3aBCl8dq77wwRBWeWHQZrafa5xyr/R0='
WHERE
key_id = '03fa9d069c827bc9563a4814056a97f8981dea3fb7008883c15fcb800d2403de'
AND (
token = 'VNEjxAR8hirv3aBCl8dq77wwRBWeWHQZrafa5xyr/R0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)