UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhpKoN1TfwtWB8OMH6RbA0/vmkzLVCd5WMVXcnWQWxA='
WHERE
key_id = '10c67f8a05666ce42292791829a5092c7c04208872d626dd2649dab8008244dd'
AND (
token = 'ZhpKoN1TfwtWB8OMH6RbA0/vmkzLVCd5WMVXcnWQWxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)