UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmPiPDgyX9EiRZ27djRhQy4WhD3YenQJ4HDeMzAJ+yU='
WHERE
key_id = '42c75823d8517b954ae04c15ff869da01ea115a82908003c759072cc9cfaec35'
AND (
token = 'tmPiPDgyX9EiRZ27djRhQy4WhD3YenQJ4HDeMzAJ+yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)