UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xyJyzM21s8WN9FhVWPPVp+nNsNdC23ycneCfiwnHaIQ='
WHERE
key_id = '6b9c3b805d4b79c03e521f68a66b35bd5525a7b4469014cc966daebfcfcba7bf'
AND (
token = 'xyJyzM21s8WN9FhVWPPVp+nNsNdC23ycneCfiwnHaIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)