UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kjMPsEe2+0+L+TaaMuvsn6pJMaU9CAAkJFvG6q8dGlg='
WHERE
key_id = 'd78813366c0d3a5c18a8de23949718015cf6d8e79e5f8a01b9b360d4783fc802'
AND (
token = 'kjMPsEe2+0+L+TaaMuvsn6pJMaU9CAAkJFvG6q8dGlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)