UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j6PXzCJrKNwRAI4XpmDlao1W00UN8ul3RBlGCsfoxKE='
WHERE
key_id = '947c4de7ac30594b22db047903d3153c18a18740161ac3cbe401bcbcf9056ff6'
AND (
token = 'j6PXzCJrKNwRAI4XpmDlao1W00UN8ul3RBlGCsfoxKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)