UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47yhFYBSgJD8rpmnI5iJTuMUUprTe69orsMDsS6+Guc='
WHERE
key_id = '19d1184d24eaa96f79667157096dee7d791678938d776d969fc2d2fe023b8fbc'
AND (
token = '47yhFYBSgJD8rpmnI5iJTuMUUprTe69orsMDsS6+Guc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)